{
  "session": {
    "queryId": "20200331_121028_00004_cpffz",
    "transactionId": "35208886-9c7c-4006-bf0e-59bca74fefd7",
    "clientTransactionSupport": true,
    "user": "hive",
    "source": "presto-cli",
    "catalog": "hive",
    "schema": "tpch",
    "timeZoneKey": 1847,
    "locale": "en_US",
    "remoteUserAddress": "127.0.0.1",
    "userAgent": "StatementClientV1/0.234-SNAPSHOT-ec684fb",
    "clientTags": [],
    "resourceEstimates": {},
    "startTime": 1585656629094,
    "systemProperties": {},
    "catalogProperties": {},
    "unprocessedCatalogProperties": {},
    "roles": {},
    "preparedStatements": {}
  },
  "extraCredentials": {},
  "fragment": "eyJpZCI6IjEiLCJyb290Ijp7IkB0eXBlIjoiLkxpbWl0Tm9kZSIsImlkIjoiMTA2Iiwic291cmNlIjp7IkB0eXBlIjoiLlRhYmxlU2Nhbk5vZGUiLCJpZCI6IjAiLCJ0YWJsZSI6eyJjb25uZWN0b3JJZCI6ImhpdmUiLCJjb25uZWN0b3JIYW5kbGUiOnsiQHR5cGUiOiJoaXZlIiwic2NoZW1hTmFtZSI6InRwY2giLCJ0YWJsZU5hbWUiOiJvcmRlcnMifSwidHJhbnNhY3Rpb24iOnsiQHR5cGUiOiJoaXZlIiwidXVpZCI6ImI4MzgwNGUyLTVhZjgtNDE1NC04NGI4LTFhNDkyMDE0YWQ5YSJ9LCJjb25uZWN0b3JUYWJsZUxheW91dCI6eyJAdHlwZSI6ImhpdmUiLCJzY2hlbWFUYWJsZU5hbWUiOnsic2NoZW1hIjoidHBjaCIsInRhYmxlIjoib3JkZXJzIn0sInBhcnRpdGlvbkNvbHVtbnMiOltdLCJkYXRhQ29sdW1ucyI6W3sibmFtZSI6Im9yZGVya2V5IiwidHlwZSI6ImJpZ2ludCJ9LHsibmFtZSI6ImN1c3RrZXkiLCJ0eXBlIjoiYmlnaW50In0seyJuYW1lIjoib3JkZXJzdGF0dXMiLCJ0eXBlIjoidmFyY2hhcigxKSJ9LHsibmFtZSI6InRvdGFscHJpY2UiLCJ0eXBlIjoiZG91YmxlIn0seyJuYW1lIjoib3JkZXJkYXRlIiwidHlwZSI6ImRhdGUifSx7Im5hbWUiOiJvcmRlcnByaW9yaXR5IiwidHlwZSI6InZhcmNoYXIoMTUpIn0seyJuYW1lIjoiY2xlcmsiLCJ0eXBlIjoidmFyY2hhcigxNSkifSx7Im5hbWUiOiJzaGlwcHJpb3JpdHkiLCJ0eXBlIjoiaW50In0seyJuYW1lIjoiY29tbWVudCIsInR5cGUiOiJ2YXJjaGFyKDc5KSJ9XSwidGFibGVQYXJhbWV0ZXJzIjp7InByZXN0b192ZXJzaW9uIjoidGVzdHZlcnNpb24iLCJwcmVzdG9fcXVlcnlfaWQiOiIyMDIwMDMzMF8xODUyMzlfMDAwMDFfY3BmZnoiLCJudW1GaWxlcyI6IjIiLCJudW1Sb3dzIjoiMTUwMDAiLCJyYXdEYXRhU2l6ZSI6IjE5NDg1NTIiLCJ0b3RhbFNpemUiOiIzMzMxMDIifSwiZG9tYWluUHJlZGljYXRlIjp7ImNvbHVtbkRvbWFpbnMiOltdfSwicmVtYWluaW5nUHJlZGljYXRlIjp7IkB0eXBlIjoiY29uc3RhbnQiLCJ2YWx1ZUJsb2NrIjoiQ2dBQUFFSlpWRVZmUVZKU1FWa0JBQUFBQUFFPSIsInR5cGUiOiJib29sZWFuIn0sInByZWRpY2F0ZUNvbHVtbnMiOnt9LCJwYXJ0aXRpb25Db2x1bW5QcmVkaWNhdGUiOnsiY29sdW1uRG9tYWlucyI6W119LCJwdXNoZG93bkZpbHRlckVuYWJsZWQiOmZhbHNlLCJsYXlvdXRTdHJpbmciOiJ0cGNoLm9yZGVyc3t9In19LCJvdXRwdXRWYXJpYWJsZXMiOlt7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoib3JkZXJrZXkiLCJ0eXBlIjoiYmlnaW50In0seyJAdHlwZSI6InZhcmlhYmxlIiwibmFtZSI6ImN1c3RrZXkiLCJ0eXBlIjoiYmlnaW50In0seyJAdHlwZSI6InZhcmlhYmxlIiwibmFtZSI6Im9yZGVyc3RhdHVzIiwidHlwZSI6InZhcmNoYXIoMSkifSx7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoidG90YWxwcmljZSIsInR5cGUiOiJkb3VibGUifSx7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoib3JkZXJkYXRlIiwidHlwZSI6ImRhdGUifSx7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoib3JkZXJwcmlvcml0eSIsInR5cGUiOiJ2YXJjaGFyKDE1KSJ9LHsiQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJjbGVyayIsInR5cGUiOiJ2YXJjaGFyKDE1KSJ9LHsiQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJzaGlwcHJpb3JpdHkiLCJ0eXBlIjoiaW50ZWdlciJ9LHsiQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJjb21tZW50IiwidHlwZSI6InZhcmNoYXIoNzkpIn1dLCJhc3NpZ25tZW50cyI6eyJvcmRlcnByaW9yaXR5PHZhcmNoYXIoMTUpPiI6eyJAdHlwZSI6ImhpdmUiLCJuYW1lIjoib3JkZXJwcmlvcml0eSIsImhpdmVUeXBlIjoidmFyY2hhcigxNSkiLCJ0eXBlU2lnbmF0dXJlIjoidmFyY2hhcigxNSkiLCJoaXZlQ29sdW1uSW5kZXgiOjUsImNvbHVtblR5cGUiOiJSRUdVTEFSIiwicmVxdWlyZWRTdWJmaWVsZHMiOltdfSwib3JkZXJzdGF0dXM8dmFyY2hhcigxKT4iOnsiQHR5cGUiOiJoaXZlIiwibmFtZSI6Im9yZGVyc3RhdHVzIiwiaGl2ZVR5cGUiOiJ2YXJjaGFyKDEpIiwidHlwZVNpZ25hdHVyZSI6InZhcmNoYXIoMSkiLCJoaXZlQ29sdW1uSW5kZXgiOjIsImNvbHVtblR5cGUiOiJSRUdVTEFSIiwicmVxdWlyZWRTdWJmaWVsZHMiOltdfSwic2hpcHByaW9yaXR5PGludGVnZXI+Ijp7IkB0eXBlIjoiaGl2ZSIsIm5hbWUiOiJzaGlwcHJpb3JpdHkiLCJoaXZlVHlwZSI6ImludCIsInR5cGVTaWduYXR1cmUiOiJpbnRlZ2VyIiwiaGl2ZUNvbHVtbkluZGV4Ijo3LCJjb2x1bW5UeXBlIjoiUkVHVUxBUiIsInJlcXVpcmVkU3ViZmllbGRzIjpbXX0sImN1c3RrZXk8YmlnaW50PiI6eyJAdHlwZSI6ImhpdmUiLCJuYW1lIjoiY3VzdGtleSIsImhpdmVUeXBlIjoiYmlnaW50IiwidHlwZVNpZ25hdHVyZSI6ImJpZ2ludCIsImhpdmVDb2x1bW5JbmRleCI6MSwiY29sdW1uVHlwZSI6IlJFR1VMQVIiLCJyZXF1aXJlZFN1YmZpZWxkcyI6W119LCJvcmRlcmRhdGU8ZGF0ZT4iOnsiQHR5cGUiOiJoaXZlIiwibmFtZSI6Im9yZGVyZGF0ZSIsImhpdmVUeXBlIjoiZGF0ZSIsInR5cGVTaWduYXR1cmUiOiJkYXRlIiwiaGl2ZUNvbHVtbkluZGV4Ijo0LCJjb2x1bW5UeXBlIjoiUkVHVUxBUiIsInJlcXVpcmVkU3ViZmllbGRzIjpbXX0sIm9yZGVya2V5PGJpZ2ludD4iOnsiQHR5cGUiOiJoaXZlIiwibmFtZSI6Im9yZGVya2V5IiwiaGl2ZVR5cGUiOiJiaWdpbnQiLCJ0eXBlU2lnbmF0dXJlIjoiYmlnaW50IiwiaGl2ZUNvbHVtbkluZGV4IjowLCJjb2x1bW5UeXBlIjoiUkVHVUxBUiIsInJlcXVpcmVkU3ViZmllbGRzIjpbXX0sImNvbW1lbnQ8dmFyY2hhcig3OSk+Ijp7IkB0eXBlIjoiaGl2ZSIsIm5hbWUiOiJjb21tZW50IiwiaGl2ZVR5cGUiOiJ2YXJjaGFyKDc5KSIsInR5cGVTaWduYXR1cmUiOiJ2YXJjaGFyKDc5KSIsImhpdmVDb2x1bW5JbmRleCI6OCwiY29sdW1uVHlwZSI6IlJFR1VMQVIiLCJyZXF1aXJlZFN1YmZpZWxkcyI6W119LCJjbGVyazx2YXJjaGFyKDE1KT4iOnsiQHR5cGUiOiJoaXZlIiwibmFtZSI6ImNsZXJrIiwiaGl2ZVR5cGUiOiJ2YXJjaGFyKDE1KSIsInR5cGVTaWduYXR1cmUiOiJ2YXJjaGFyKDE1KSIsImhpdmVDb2x1bW5JbmRleCI6NiwiY29sdW1uVHlwZSI6IlJFR1VMQVIiLCJyZXF1aXJlZFN1YmZpZWxkcyI6W119LCJ0b3RhbHByaWNlPGRvdWJsZT4iOnsiQHR5cGUiOiJoaXZlIiwibmFtZSI6InRvdGFscHJpY2UiLCJoaXZlVHlwZSI6ImRvdWJsZSIsInR5cGVTaWduYXR1cmUiOiJkb3VibGUiLCJoaXZlQ29sdW1uSW5kZXgiOjMsImNvbHVtblR5cGUiOiJSRUdVTEFSIiwicmVxdWlyZWRTdWJmaWVsZHMiOltdfX19LCJjb3VudCI6MTAsInN0ZXAiOiJQQVJUSUFMIn0sInZhcmlhYmxlcyI6W3siQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJvcmRlcmtleSIsInR5cGUiOiJiaWdpbnQifSx7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoiY3VzdGtleSIsInR5cGUiOiJiaWdpbnQifSx7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoib3JkZXJzdGF0dXMiLCJ0eXBlIjoidmFyY2hhcigxKSJ9LHsiQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJ0b3RhbHByaWNlIiwidHlwZSI6ImRvdWJsZSJ9LHsiQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJvcmRlcmRhdGUiLCJ0eXBlIjoiZGF0ZSJ9LHsiQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJvcmRlcnByaW9yaXR5IiwidHlwZSI6InZhcmNoYXIoMTUpIn0seyJAdHlwZSI6InZhcmlhYmxlIiwibmFtZSI6ImNsZXJrIiwidHlwZSI6InZhcmNoYXIoMTUpIn0seyJAdHlwZSI6InZhcmlhYmxlIiwibmFtZSI6InNoaXBwcmlvcml0eSIsInR5cGUiOiJpbnRlZ2VyIn0seyJAdHlwZSI6InZhcmlhYmxlIiwibmFtZSI6ImNvbW1lbnQiLCJ0eXBlIjoidmFyY2hhcig3OSkifV0sInBhcnRpdGlvbmluZyI6eyJjb25uZWN0b3JIYW5kbGUiOnsiQHR5cGUiOiIkcmVtb3RlIiwicGFydGl0aW9uaW5nIjoiU09VUkNFIiwiZnVuY3Rpb24iOiJVTktOT1dOIn19LCJ0YWJsZVNjYW5TY2hlZHVsaW5nT3JkZXIiOlsiMCJdLCJwYXJ0aXRpb25pbmdTY2hlbWUiOnsicGFydGl0aW9uaW5nIjp7ImhhbmRsZSI6eyJjb25uZWN0b3JIYW5kbGUiOnsiQHR5cGUiOiIkcmVtb3RlIiwicGFydGl0aW9uaW5nIjoiU0lOR0xFIiwiZnVuY3Rpb24iOiJTSU5HTEUifX0sImFyZ3VtZW50cyI6W119LCJvdXRwdXRMYXlvdXQiOlt7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoib3JkZXJrZXkiLCJ0eXBlIjoiYmlnaW50In0seyJAdHlwZSI6InZhcmlhYmxlIiwibmFtZSI6ImN1c3RrZXkiLCJ0eXBlIjoiYmlnaW50In0seyJAdHlwZSI6InZhcmlhYmxlIiwibmFtZSI6Im9yZGVyc3RhdHVzIiwidHlwZSI6InZhcmNoYXIoMSkifSx7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoidG90YWxwcmljZSIsInR5cGUiOiJkb3VibGUifSx7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoib3JkZXJkYXRlIiwidHlwZSI6ImRhdGUifSx7IkB0eXBlIjoidmFyaWFibGUiLCJuYW1lIjoib3JkZXJwcmlvcml0eSIsInR5cGUiOiJ2YXJjaGFyKDE1KSJ9LHsiQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJjbGVyayIsInR5cGUiOiJ2YXJjaGFyKDE1KSJ9LHsiQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJzaGlwcHJpb3JpdHkiLCJ0eXBlIjoiaW50ZWdlciJ9LHsiQHR5cGUiOiJ2YXJpYWJsZSIsIm5hbWUiOiJjb21tZW50IiwidHlwZSI6InZhcmNoYXIoNzkpIn1dLCJyZXBsaWNhdGVOdWxsc0FuZEFueSI6ZmFsc2UsImJ1Y2tldFRvUGFydGl0aW9uIjpbMF19LCJzdGFnZUV4ZWN1dGlvbkRlc2NyaXB0b3IiOnsic3RhZ2VFeGVjdXRpb25TdHJhdGVneSI6IlVOR1JPVVBFRF9FWEVDVVRJT04iLCJncm91cGVkRXhlY3V0aW9uU2Nhbk5vZGVzIjpbXSwidG90YWxMaWZlc3BhbnMiOjF9LCJvdXRwdXRUYWJsZVdyaXRlckZyYWdtZW50IjpmYWxzZSwic3RhdHNBbmRDb3N0cyI6eyJzdGF0cyI6e30sImNvc3RzIjp7fX0sImpzb25SZXByZXNlbnRhdGlvbiI6IntcbiAgXCJpZFwiIDogXCIxMDZcIixcbiAgXCJuYW1lXCIgOiBcIkxpbWl0UGFydGlhbFwiLFxuICBcImlkZW50aWZpZXJcIiA6IFwiWzEwXVwiLFxuICBcImRldGFpbHNcIiA6IFwiXCIsXG4gIFwiY2hpbGRyZW5cIiA6IFsge1xuICAgIFwiaWRcIiA6IFwiMFwiLFxuICAgIFwibmFtZVwiIDogXCJUYWJsZVNjYW5cIixcbiAgICBcImlkZW50aWZpZXJcIiA6IFwiW1RhYmxlSGFuZGxlIHtjb25uZWN0b3JJZD0naGl2ZScsIGNvbm5lY3RvckhhbmRsZT0nSGl2ZVRhYmxlSGFuZGxle3NjaGVtYU5hbWU9dHBjaCwgdGFibGVOYW1lPW9yZGVycywgYW5hbHl6ZVBhcnRpdGlvblZhbHVlcz1PcHRpb25hbC5lbXB0eX0nLCBsYXlvdXQ9J09wdGlvbmFsW3RwY2gub3JkZXJze31dJ31dXCIsXG4gICAgXCJkZXRhaWxzXCIgOiBcIkxBWU9VVDogdHBjaC5vcmRlcnN7fVxcbm9yZGVycHJpb3JpdHkgOj0gb3JkZXJwcmlvcml0eTp2YXJjaGFyKDE1KTo1OlJFR1VMQVJcXG5vcmRlcnN0YXR1cyA6PSBvcmRlcnN0YXR1czp2YXJjaGFyKDEpOjI6UkVHVUxBUlxcbnNoaXBwcmlvcml0eSA6PSBzaGlwcHJpb3JpdHk6aW50Ojc6UkVHVUxBUlxcbmN1c3RrZXkgOj0gY3VzdGtleTpiaWdpbnQ6MTpSRUdVTEFSXFxub3JkZXJkYXRlIDo9IG9yZGVyZGF0ZTpkYXRlOjQ6UkVHVUxBUlxcbm9yZGVya2V5IDo9IG9yZGVya2V5OmJpZ2ludDowOlJFR1VMQVJcXG5jb21tZW50IDo9IGNvbW1lbnQ6dmFyY2hhcig3OSk6ODpSRUdVTEFSXFxuY2xlcmsgOj0gY2xlcms6dmFyY2hhcigxNSk6NjpSRUdVTEFSXFxudG90YWxwcmljZSA6PSB0b3RhbHByaWNlOmRvdWJsZTozOlJFR1VMQVJcXG5cIixcbiAgICBcImNoaWxkcmVuXCIgOiBbIF0sXG4gICAgXCJyZW1vdGVTb3VyY2VzXCIgOiBbIF1cbiAgfSBdLFxuICBcInJlbW90ZVNvdXJjZXNcIiA6IFsgXVxufSJ9",
  "sources": [
    {
      "planNodeId": "0",
      "splits": [
        {
          "sequenceId": 0,
          "planNodeId": "0",
          "split": {
            "connectorId": "hive",
            "transactionHandle": {
              "@type": "hive",
              "uuid": "b83804e2-5af8-4154-84b8-1a492014ad9a"
            },
            "connectorSplit": {
              "@type": "hive",
              "database": "tpch",
              "table": "orders",
              "partitionName": "<UNPARTITIONED>",
              "path": "file:/var/folders/wf/bbxcg3ld53n5p7t5jtq1xd480000gn/T/PrestoTest3068722784213624545/hive_data/tpch/orders/20200330_185239_00001_cpffz_b41ce481-3302-442d-b7a4-a5810a944eee",
              "start": 0,
              "length": 166921,
              "fileSize": 166921,
              "cacheQuota": {"cacheQuotaScope": "TABLE"},
              "storage": {
                "storageFormat": {
                  "serDe": "org.apache.hadoop.hive.ql.io.orc.OrcSerde",
                  "inputFormat": "org.apache.hadoop.hive.ql.io.orc.OrcInputFormat",
                  "outputFormat": "org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat"
                },
                "location": "file:/var/folders/wf/bbxcg3ld53n5p7t5jtq1xd480000gn/T/PrestoTest3068722784213624545/hive_data/tpch/orders",
                "skewed": false,
                "serdeParameters": {},
                "parameters": {}
              },
              "partitionKeys": [],
              "addresses": [],
              "nodeSelectionStrategy": "NO_PREFERENCE",
              "partitionDataColumnCount": 9,
              "partitionSchemaDifference": {},
              "s3SelectPushdownEnabled": false
            },
            "lifespan": "TaskWide",
            "splitContext": {
              "cacheable": false
            }
          }
        }
      ],
      "noMoreSplitsForLifespan": [],
      "noMoreSplits": false
    }
  ],
  "outputIds": {
    "type": "PARTITIONED",
    "version": 2,
    "noMoreBufferIds": true,
    "buffers": {
      "0": 0
    }
  },
  "tableWriteInfo": {}
}
